What are the challenges and methods of index optimization in MySQL databases